UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r8CWw4YPsHV+emQfKadsX/aHcPNjhzyvsdIE3ulzmpI='
WHERE
key_id = '7f8bf49aaadbe85d146cf569c00d2e6106f6c26d51fcc1725912f33ae50e571d'
AND (
token = 'r8CWw4YPsHV+emQfKadsX/aHcPNjhzyvsdIE3ulzmpI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)