UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4XPrJpyycIzlMe9RzgDs7j+OIX26g54Gb1Own3nRnX8='
WHERE
key_id = 'bcf4c9a4630770b603ac8e237f02219f8fdaa4abd21a9dd469760fd922b4969a'
AND (
token = '4XPrJpyycIzlMe9RzgDs7j+OIX26g54Gb1Own3nRnX8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)