UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4EcGggJNiQPLY4daHX8WyNv7jqN1//1nZdbpeLMFPpU='
WHERE
key_id = 'cea0b904fed8bdd76754eae7c6ce9227fcbc93d51c71c33809df14d45d30a19c'
AND (
token = '4EcGggJNiQPLY4daHX8WyNv7jqN1//1nZdbpeLMFPpU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)