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