UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tXA6CVpfwxEaxc++T0dH2dEUNw0HFHX5LulHVxnD89E='
WHERE
key_id = '27ce0f6b3725d01ed6bb88032ea5c8bfd63bcc61eca6b311eb2cf4021b911780'
AND (
token = 'tXA6CVpfwxEaxc++T0dH2dEUNw0HFHX5LulHVxnD89E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)