UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pMaCiM7y/w+TdumdjBcgO8V9cm74MOtLYq79eurccYI='
WHERE
key_id = 'c0fe9421e6143eb3325d12826bfde51d36a13ce0d2398de4aef77ff345a24d4d'
AND (
token = 'pMaCiM7y/w+TdumdjBcgO8V9cm74MOtLYq79eurccYI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)