UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'VNoKnZA6yr5mGzw9fqIT+6ItpfaQssPl1OfV/Eb0ebA=' 
WHERE 
  key_id = '40cc264f21355ea6f9991bbaa67165de1e68f8c748b01f94a14164ca15e9b0b4' 
  AND (
    token = 'VNoKnZA6yr5mGzw9fqIT+6ItpfaQssPl1OfV/Eb0ebA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034