UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xifaHwqEJWMJ4rYATD0wQiWSqV48g3S0usQdeX1vkMs='
WHERE
key_id = '1c991a64e5147d7c394a91e819d91886a87c27df1c9a1195089303812cea5ff4'
AND (
token = 'xifaHwqEJWMJ4rYATD0wQiWSqV48g3S0usQdeX1vkMs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)