UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pw/9DK24tyY19i0LJ6F8CSI+fMbn42XeG5AaV1iQy6Y='
WHERE
key_id = 'd6528bb8d5d966d13086b1f69b8654ed86337fc4ef33043a07c9e1af2dec90ac'
AND (
token = 'pw/9DK24tyY19i0LJ6F8CSI+fMbn42XeG5AaV1iQy6Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)