UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X+uZcDZUgldsZ9CobblwrH3J7qD3jGBBSX5xWyskyvs='
WHERE
key_id = '8d0dfe261d9e40f0e84fc55c494b3a41d4332748973ffded0f20bbfe33f41265'
AND (
token = 'X+uZcDZUgldsZ9CobblwrH3J7qD3jGBBSX5xWyskyvs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)