SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '9fa2b0ce87a1481601a3c89d16aa7ea62310ef6f52e9e723f0710a29891feb35' 
  AND token = 'OLoSq5h/jBGwu7J2SkvNqC3QrJUu8kf35eNVrm+OjEc=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00024

JSON explain

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