UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IyWlAaVCp6QITPYZu31+cTKJDMyJgX6YpGAVYYAbTZw='
WHERE
key_id = '2021a9381706f6037740ca16af754d28788ed8ddadf8f2ccd41dce2497dae300'
AND (
token = 'IyWlAaVCp6QITPYZu31+cTKJDMyJgX6YpGAVYYAbTZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)