UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0bZHeH9XdNJLNaK3d+V9DTWf733JOAfljpPut73QOcE='
WHERE
key_id = 'f7696f49d219f07b5cac3aabd28a3b2b08f4426ffad5832ae66d18a8a6e0d102'
AND (
token = '0bZHeH9XdNJLNaK3d+V9DTWf733JOAfljpPut73QOcE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)