UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KGizug5CjWphSPSTV/IbvR7oY/FLHb6LYRr+WhRSwVA='
WHERE
key_id = 'd2d1706b3bf704c924219c678439776f598458f8908be2fff4fcd3c06765adaf'
AND (
token = 'KGizug5CjWphSPSTV/IbvR7oY/FLHb6LYRr+WhRSwVA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)