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