UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3It9qgENyZ/oGHUpwVXgRI1eFg2AcTu23POlEf8aZgo='
WHERE
key_id = '5454bf25beb08d325bae006ef92a238598f08effc1a8229dd5448c89471b8352'
AND (
token = '3It9qgENyZ/oGHUpwVXgRI1eFg2AcTu23POlEf8aZgo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)