UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4FhgPGKoLgV9VlIxghmLxQmzRvytuSRZsbygLYI1oyg='
WHERE
key_id = '4118a78d3bae98c2bc2eb7c56071d4f5ff17340e02fa93c36e1b9dc73250fa33'
AND (
token = '4FhgPGKoLgV9VlIxghmLxQmzRvytuSRZsbygLYI1oyg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)