SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '90cd75633c48f16d4f06d41098b3c58a0917acb071d8969364b39f0e3ffad706' 
  AND token = '7i3amw3SKTEpE1g7ofhrOxvIPf1Ha1Sanb+4qdDdFEk=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00019

JSON explain

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