UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZVmLyi0RbFNjQ5NCudNjg3i1HTfTGHNJXNeuPDCtp7A='
WHERE
key_id = '78d735bcff7c8c707fd818b081d8b8b4fede7c030917e59e7da792de97bf41c2'
AND (
token = 'ZVmLyi0RbFNjQ5NCudNjg3i1HTfTGHNJXNeuPDCtp7A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)