UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tGp3BbpvotU8pWJuJH/+Vnze6dFR8o+l5PjJaJQa54E='
WHERE
key_id = 'a89d925b8559a3f931eb65f254b8ff941e2c1be7025f3e593c33cd9bb5167645'
AND (
token = 'tGp3BbpvotU8pWJuJH/+Vnze6dFR8o+l5PjJaJQa54E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)