UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XNi71UmasO13G7BeAXGHskVADBD+dkorSd8swylKnZY='
WHERE
key_id = 'a34461e412ae8b06e31bac8f04ef41b63afa0a426b1908fe6696406fffe9f988'
AND (
token = 'XNi71UmasO13G7BeAXGHskVADBD+dkorSd8swylKnZY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)