UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NnO7YqsPQ1K87SZPhbik09AwraPCj5zIebOVkD3F0sw='
WHERE
key_id = '2e74f6762b6eaebd5adb3cb9a30faa3f1d02cf8492623b403cd03d66237aa211'
AND (
token = 'NnO7YqsPQ1K87SZPhbik09AwraPCj5zIebOVkD3F0sw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)