SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'a12292d671107f33bf2bbf689a5c7169afcdd4540e76180236b1d7d1293b8c70' 
  AND token = 'wsZ8SyQx51T6fSoJQZi0O8N2uVyz1Luv0o0pb8kT270=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00015

JSON explain

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