UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9jF0q8uzGEsA036i27+efyp5sZCu9EsvqjY9EpCH8So='
WHERE
key_id = '2947c7a7dd351d0991497421816268d043e86589162784d534679b90034e614a'
AND (
token = '9jF0q8uzGEsA036i27+efyp5sZCu9EsvqjY9EpCH8So='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)