SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '94d4100ddbf14aa7e12286b1b46018834c4dbc966f07aa0b964f45de62324514' 
  AND token = 'j7AnFYRVyMfOJQDwumYVwiz3uOEfchR07BRH9EVQZ9k=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00027

JSON explain

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