UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9BX9cuMuPogSgBAB82mmLjnVkj0caoOrUlKnNLNBqpk='
WHERE
key_id = '621c04fc7415518ead1ef21013190f009ed893e128cd3878a6d4bd8aa8bf9578'
AND (
token = '9BX9cuMuPogSgBAB82mmLjnVkj0caoOrUlKnNLNBqpk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)