UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ylT7/hnjexrtJjd8VyJrH+OifkfyArIMojn9miX/arU='
WHERE
key_id = 'a9ce55dad9b6c99523e94dbc0031f8c857a271043b15ae35afb685e59443777b'
AND (
token = 'ylT7/hnjexrtJjd8VyJrH+OifkfyArIMojn9miX/arU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)