SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '24d4611b26138d5c8af976f8e29c5c4237e49ce3f1d063fa4414d643bb5fd23d' 
  AND token = '6CyU45jP1eMhnqfx7/cps5HQa5GF+OVaoc7LIpt/mJU=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00043

JSON explain

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