SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'ee5f6b3ef8f4600ca9bed3143640ebc331e15c04e759a212c3a03a16a07e8abb' 
  AND token = 'dTq2L1XCIGV4LS8sRzfREetXQ/E7ddBR9r+Bo6UYpdM=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00024

JSON explain

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