UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O1xWaSWiJd9xYHTAOxE4lA7UnLZydiGJoemNXOMsrHU='
WHERE
key_id = '3d7e4b6af07428f51efc26ef2fa8be8c5329454483d9542d022a5bf31ae40e0b'
AND (
token = 'O1xWaSWiJd9xYHTAOxE4lA7UnLZydiGJoemNXOMsrHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)