UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nQG4yM+Os7eeRJVmAlBWzrh1RRruKdLk4IfY/QGVuG0='
WHERE
key_id = 'd9128a7cec27fd235582cc9f416d16b6ec3964abe249e17d116eaa7d960e053a'
AND (
token = 'nQG4yM+Os7eeRJVmAlBWzrh1RRruKdLk4IfY/QGVuG0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)