SELECT 
  1 
FROM 
  cscart_aprillock_keys 
WHERE 
  key_id = '6d2ec2d37dc401b28d87e9b37b5fa2093e6b2fe19f6e0fb8332e36a127e5b43d' 
  AND token = 'wSERwjHQG7+EATn+yQ+XVMyDHpQULdlgA20iuufYH2Y=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00021

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}