UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LnVr9JwnSuAobpquv3kXgI0NLa5TMeDE0BM0BC0YKeY='
WHERE
key_id = '912f397ac301d2d00787c053cd1a289ef8b2c1dcaa7bbdf5b0267ba1dafa8080'
AND (
token = 'LnVr9JwnSuAobpquv3kXgI0NLa5TMeDE0BM0BC0YKeY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)