UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TQVndrjjpIJssIx3W3J9SyMOojDALTpkOwBGKFU8TMA='
WHERE
key_id = '407a5494f44d1c149749c2f274681e7e0079a140dbe246e15f3753607be5a7cb'
AND (
token = 'TQVndrjjpIJssIx3W3J9SyMOojDALTpkOwBGKFU8TMA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)