SELECT 
  1 
FROM 
  cscart_aprillock_keys 
WHERE 
  key_id = '770327b403319ea2af9617edfa4baa4456b5f4666c06ac81d7e24bbc3f668a2b' 
  AND token = 'ffu0o231tEmTAXP0fNWI/UGY2X1aaGpugO0HN7hNSjI=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00035

JSON explain

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