UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b64fII9XiuT8AmE3NUbZmoWNAD+9RJL0V4H6phj+w+Y='
WHERE
key_id = '2792aeb7a856a9ef889b2d61907956ab66ec0866a16d1caa36908c316d69030c'
AND (
token = 'b64fII9XiuT8AmE3NUbZmoWNAD+9RJL0V4H6phj+w+Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)