UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Njdv0JW4eUWnZ/Gu4OnweGBMlhYETo31rH1WnCSVHgw='
WHERE
key_id = 'c7b9a1a46388bd7bced034663c9dfc3f48142c38329252f1b2cfe7f4848758a2'
AND (
token = 'Njdv0JW4eUWnZ/Gu4OnweGBMlhYETo31rH1WnCSVHgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)