SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'cec878f26d9bd0b3081dce4a684d1e3ccc50485263dcd36b33f462b69e638a63' 
  AND token = '97yGCc5mf1uDGWqGADQ8GylgAal7NimRpZxUqp9V8zw=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00027

JSON explain

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