UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RMD6wZWtPVPo4yeW0D34MxWj/YS9Qv9wXVqBkWtVOKM='
WHERE
key_id = '5ffc8dd04994eb78e058b6c6f3124309d211fa209b29ce8d0ed7efd94447b3c2'
AND (
token = 'RMD6wZWtPVPo4yeW0D34MxWj/YS9Qv9wXVqBkWtVOKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)