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

Query time 0.00022

JSON explain

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