UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XO83EyaJXU2uVUTM5HEDXDd7YWBaeB4GHZvvmWVsCUM='
WHERE
key_id = 'df65ef674f8c1f13f46fb2d854cdd69aa3cc26ff783bb79aad1222408c8fe72d'
AND (
token = 'XO83EyaJXU2uVUTM5HEDXDd7YWBaeB4GHZvvmWVsCUM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)