UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CPtM6cMwHGH/t2uD4PT6zyHjngLHG5k5giKMMQ1HqaM='
WHERE
key_id = 'd34c7257485061f5a47f8dc0a57e604615061de1a83d5530d89e26b8e5f38107'
AND (
token = 'CPtM6cMwHGH/t2uD4PT6zyHjngLHG5k5giKMMQ1HqaM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)