UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v+yAH7HNlMMUh8YMIo5UcqRHORFqfhQz9vz6kHZSHBw='
WHERE
key_id = 'd170ba0a97448ae401202ba9994eb63ed8d31ff544616d39d95e31f0e0de3ecc'
AND (
token = 'v+yAH7HNlMMUh8YMIo5UcqRHORFqfhQz9vz6kHZSHBw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)