SELECT 
  1 
FROM 
  cscart_aprillock_keys 
WHERE 
  key_id = '0afbff8b51d499f7c62071a97b012df35b67311ec2e8248026d2f3c52e30bcad' 
  AND token = 'KtxOQ2IL5wI7IRx/s5YA0Im0MT+nQDQSCe/N7yE/iTg=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00039

JSON explain

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